We don't bite newbies here... much | |
PerlMonks |
Re^3: Calling Oracle StoredProc using Win32:ODBCby roboticus (Chancellor) |
on Jan 12, 2013 at 03:56 UTC ( [id://1013005]=note: print w/replies, xml ) | Need Help?? |
As the Anonymous Monk states above, it's the namespace the package resides in. I'm using DBI with DBD::Oracle, so the code may not be exactly what Win32::ODBC would use. The code would be something like:
But in any case, to call the procedure, you just use a "call SPROC(args...)" statement as you would normally use "select * from table". The difficulty may be in returning a recordset. For DBD::Oracle we bind another variable ($ST_result above) to the output cursor, and then we can treat it as a statement handle and retrieve the results from it. You'll have to fiddle with that to make it work in Win32::ODBC. ...roboticus When your only tool is a hammer, all problems look like your thumb.
In Section
Seekers of Perl Wisdom
|
|