INFORMIX

[Ricky B. Nino]

Hi,

I created a STORED PROCEDURE.

I called this STORED PROCEDURE within my 4GL script.

The problem is that the STORED PROCEDURE cannot be recognize by my 4GL script.

Error message when I compile my is...

"The following errors were discovered during compilation.
/usr/ccs/bin/ld: Unsatisfied symbols:
sp_lpcnt (first referenced in pe_rpt2.o) (code)"

TIA...

[Rainer von Bongartz]

What Informix server version ??

is your SHLIB_PATH configured correctly.


For IDS 9.3 and above it should include
$INFORMIXDIR/lib


Regards
Rainer

[Steve Lewis]

You don't call a stored procedure using the CALL command, but by preparing and executing an SQL statement. e.g. I have a stored procedure called set_role()

To call it you have to do this:

define x char(2000)

let x="execute procedure set_role()"

prepare p_stmt from x

execute p_stmt

If you try to CALL stored_proc you get the error that you mentioned.