CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
Oraclele.pm procedure question?

 



ggww
New User

Aug 18, 2009, 2:35 PM

Post #1 of 1 (2611 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

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives