Other Oracle database topics - How to parameterize a pro *c function with a default value

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to parameterize a pro *c function with a default value

2006-02-25, 9:34 am

Hi,

Can anybody confirm whether pro c supports default arguments or not. I
need this to use NOWAIT on a SELECT ... FOR UPDATE statement.

I need to open a cursor using SELECT ... FOR UPDATE and with a NOWAIT.
Can I make this NOWAIT as optional by any chance? I have to pass it
only on certain situations.

Could anybody suggest regarding this. It very urgent to me.

Thanks in advance..

sybrandb@yahoo.com

2006-02-25, 9:34 am

clear case of dynamic sql. Which usually scales badly. An alternatieve
would be
if <some condition from parameter list> then
select for update ...
now wait
else
select for update

One would question what is the conceptual 'logic' behind this.

--
Sybrand Bakker
Senior Oracle DBA

Sponsored Links