Help-Stored Procedure

Posted in 1995

Shyama Somarajan — Thu, 20 Apr 1995 05:29:11 CDT — source: Informix-list mailing list archive (1991-1998)

Hi, I am running an esql/c file where a stored procedure is created and then later executed. All of this is done using PREPARE and EXECUTE since the user gives the name of the procedure. Within the procedure, tables are to be created and values are to be inserted. Creation of the procedure goes fine w/o problems, but the tables don't get created. I tried to run the procedure from dbaccess also, but the tables are not created. I don't get any error messages and I do have SET EXCEPTION statements in case any esql errors occur. I am using esql/c ver 5.03 on Sequent Unix Systems and do have previlages for tables,stored procedures. I did check the PREPARE statements (for creating and executing procedure) and didn't find any errors. If you have any suggestions or ideas as to why this might be happening, please send me a mail. I will appreciate any input to this problem. Thanks in advance. Shyama.