Subject RE: [IBO] SP Urgent!!!
Author Jason Wharton
There are two ways to execute a stored procedure.
Which are you intending to do and what does the SQL trace say you are doing.

Check the StoredProcForSelect property (or something spelled like that).


> -----Original Message-----
> From: radevojvodic [mailto:rvojvodic@...]
> Sent: Thursday, March 10, 2005 2:51 AM
> To:
> Subject: [IBO] SP Urgent!!!
> 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....