Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1013213]
[marto]: LanX: I appreciate that, it's honestly a difficult thing, a fine balance
[marto]: I'm sure it'll be fun :)
[marto]: of course I can take you to some of the best/worst bars in Glasgow ;)
[LanX]: is Glasgow that city where catholics and protestants fight in bars? ; )
[marto]: not really, but pick your side, we'll visit some real dumps

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (13)
As of 2017-12-14 15:56 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (397 votes). Check out past polls.