Subject | SP Urgent!!! |
---|---|
Author | radevojvodic |
Post date | 2005-03-10T09:51:07Z |
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....
RADE
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....
RADE