Subject Re: SP Urgent!!!
Author Svein Erling Tysvær
--- In, Rade Vojvodic wrote:
> Hi All,
> I have a stored procedure which is called from application with
> IBobjects' TIB_StoredProc. The problem is that i have an select
> statement which should generate an exception in SP. Calling a stored
> procedure from IB_console works OK and it produces an exception, but
> if I call the same procedure from my application an exception is not
> generated and stored procedure executes normaly (and it should not).
> Does anyone know the reason. Is there a known problem with select
> statement and exists clause
> e.g.
> if( exists(
> Select 1 From RDB$DATABASE
> Where exists(Select...)
> ) then
> Exception E....

Hi Rade!

I don't know anything about your problem, but you do an unneccessary
double exists. Your above statement can be simplified to

if( exists(Select...)
) then
Exception E....

i.e. drop the "Select 1 From RDB$DATABASE Where exists(" part.

Though I don't know whether this will help anything,