Re: Execute a stored procedure from OCI

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Fri, 04 Jan 2002 11:26:10 -0600
Message-ID: <r7pb3u8c3a3rpfdmpjsjjnt2l2j7g4m7t2@4ax.com>

Please list the varying error messages.. meanwhile,
Check:
Are you logged in as the owner of the procedure? If not, use the fully qualified name SCHEMAOWNER.INSERT_ROOM(), assuming you have permission to use it, and to insert into the table
the syntax ( if room is a NUMBER ) is EXEC INSERT_ROOM(45)

"Rolf C Stadheim" <r-stadhe_at_online.no> wrote:

>How can I execute a stored procedure (a non-select procedure that inserts a
>row) from an OCI C-routine?
>
>I have tried
>
>'EXECUTE INSERT_ROOM(45)',
>'EXEC SQL INSERT_ROOM(45)',
>'BEGIN INSERT_ROOM(45) END;',
>'BEGIN INSERT_ROOM(45);'
>
>but all fails with varying error-messages.
>
>I'm using the Oracle 7.3 OCI libraries.
>
>RCS
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Fri Jan 04 2002 - 11:26:10 CST