Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^2: Calling Oracle StoredProc using Win32:ODBC

by mje (Curate)
on Jan 14, 2013 at 13:21 UTC ( #1013213=note: print w/replies, xml ) Need Help??


in reply to Re: Calling Oracle StoredProc using Win32:ODBC
in thread Calling Oracle StoredProc using Win32:ODBC

You may already know this and not care but I'd be careful using "call" as it gobbles up NO_DATA_FOUND errors. I've been bitten by this myself in the past and it is documented by Oracle but I cannot remember where now. We switched to use "begin package.proc(?); end;" syntax ages ago which does not suffer the same problem.

  • Comment on Re^2: Calling Oracle StoredProc using Win32:ODBC

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1013213]
help
Chatterbox?
[jdporter]: It doesn't have to be line by line. Just "my program" "writes" to the external prog and also/then "reads" from it.
LanX open (You are not allowed to open to a command that pipes both in and out, but see IPC::Open2, IPC::Open3, and Bidirectional Communication with Another Process in perlipc for alternatives.)
[jdporter]: IPC::Open2, I guess
[jdporter]: yes, that
[pryrt]: 1nickt: academically, perl -MDevel::Peek -lE 'Dump(42); Dump(42.0)'
[chacham]: have you ever wanted to vote -- on a post because of the signature?
[LanX]: susure

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (12)
As of 2017-05-24 20:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?