ggww
New User
Aug 18, 2009, 2:35 PM
Post #1 of 1
(1973 views)
|
|
Oraclele.pm procedure question?
|
Can't Post
|
|
Hi,
I have a procedure in Oracle that is defined as:
GEN.MISC.GEN_IMAGE ( RES OUT CURSOR_TYPE, DOCID IN VARCHAR2, KLESS IN CHAR );
Here is a portion of my source code:
***************************************************
use DBD::Oracle qw(:ora_types);
my $oradb = OracleConnect->new( { config => "$httpdroot/MP-config/oracledb.conf" } );
my $bib = $oradb->{dbh};
return {} unless defined $oradb && defined $bib;
my $sth;
my $sth_cursor;
my $p2 = "IMG123";
my $p3 = "Y";
eval {
$sth = $bib->prepare(q{
BEGIN
GEN.MISC.GEN_IMAGE(:p1,:p2,:p3);
END;
});
$sth->bind_param_inout(":p1", \$sth_cursor, 0, {ora_type=>ORA_RSET});
$sth->bind_param(":p2",$p2);
$sth->bind_param(":p3",$p3);
my $res = $sth->execute();
};
***************************************************
I am getting the following error in my log file:
DBD::Oracle::st execute failed: ORA-00911: invalid character
ORA-06512: at "GEN.MISC", line 32
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute) [for Statement "
BEGIN
GEN.MISC.GEN_IMAGE(:p1,:p2,:p3);
END;
" with ParamValues: :p1=DBI::st=HASH(0x640970), :p2='IMG123', :p3='Y'] at /usr/local/etc/httpd.jan2009tip/perlmods/Clips/FastClip9.pm line 905.
ORA-00911: invalid character
How should I be calling this procedure?
Thanks a bunch,
G
|
MAIN
SEARCH
WHO'S 
LOG 