Hi all..
Does anyone know have an example of passing the contents of a ksharray to oracle?
basically I am looking to loop through the contents of a file and store each line into a bash ksh. Once i have this I can then pass the array into an oracle procedure that accepts an array as an... (1 Reply)
Hi Folks,
The subject is my question:
Can we pass an array of strings from a Perl Program to a Shell Script?
Please provide some sample code.
Thanks
---------- Post updated at 11:52 PM ---------- Previous update was at 11:43 PM ----------
I got it.
Its here:... (0 Replies)
Hi,
I am in the need of doing a bulk insert via :
SQL - INSERT INTO <table> (SELECT..)
OR
PLSQL Block - FORALL i IN 1 .. count INSERT INTO <table>(arrayname(i))
I have a 2D array in my perl code which has the rows to be bulk inserted.
Is there a way to bind the 2D array to the SQL... (4 Replies)
Hi,
I have an array of strings. Each string has 4 comma separated values. I am binding this array to a SQL where I am required to do an INSERT after grouping.
The binding is done as :
$insertADWSth->bind_param_array(1,A_CONSTANT_STRING);... (1 Reply)
Hi All ,
I am trying to pass a value from sqlplus to korn shell .
There is a table tab1 in Oracle that has a column userdate.
I need to pass the userdate to the korn shell . This is what I am doing .
VALUE=`sqlplus -silent username/password << END
set pagesize 0 feedback off verify off... (14 Replies)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Hi all,
Hopefully you can help. This is what I'm trying to achieve:
Obtain a list of usernames out of an Oracle Database
Based on this list, link each username with an Oracle Internet Directory (OID) GUID
Using the username and GUID perform a database update for all users
Here are the... (7 Replies)
Discussion started by: exm
7 Replies
LEARN ABOUT DEBIAN
ropkg::simba::commands
RoPkg::Simba::Commands(3pm) User Contributed Perl Documentation RoPkg::Simba::Commands(3pm)NAME
RoPkg::Simba::Commands
VERSION
0.2.2
DESCRIPTION
RoPkg::Simba::Commands is a class used to count and get the commands from the database.
SYNOPSIS
!#/usr/bin/perl
use RoPkg::DB;
use RoPkg::Simba::Commands;
sub main {
my $dbp = new RoPkg::DB();
$dbp->Add('dbi:mysql:database=mysql;host=localhost',
'root',
'',
'local');
my $m = new RoPkg::Simba::Commands(dbo => $dbp, dbo_method => 'db_local');
print $m->Count,' commands found in database',$/;
}
main();
SUBROUTINES /METHODS
new()
The class constructor. At this moment, it just calls RoPkg::DBObject->new() . Please read the RoPkg::DBObject manual page for more
information about the new() parameters.
Count($fields)
Returns the number of commands from database. The $fields parameter contains a list of WHERE clauses. For more details of $fields see
SQL::Abstract.
Get($fields, $orderby)
Returns a array of RoPkg::Simba::Command objects. The commands are read from the database. The $fields parameter contains a list of WHERE
clauses. For more details of $fields see SQL::Abstract. $orderby is a reference to a array holding the fields specification used for
sorting the data.
DIAGNOSTICS
Unpack the source and use 'make test' command
CONFIGURATION AND ENVIRONMENT
This module does not use any configuration files or environment variables.
DEPENDENCIES
RoPkg::DBCollection and RoPkg::Exceptions
INCOMPATIBILITIES
None known to the author
BUGS AND LIMITATIONS
None know to the author
PERL CRITIC
The code is perl critic level 2 compliant
SEE ALSO
RoPkg::Simba RoPkg::Simba::Command SQL::Abstract
AUTHOR
Subredu Manuel <diablo@iasi.roedu.net>
LICENSE AND COPYRIGHT
Copyright (C) 2005 Subredu Manuel. All Rights Reserved. This module is free software; you can redistribute it and/or modify it under the
same terms as Perl itself. The LICENSE file contains the full text of the license.
perl v5.14.2 2006-07-04 RoPkg::Simba::Commands(3pm)