Re: Execute a stored procedure from OCI

The error messages were (translated from my locale to English):

For 'EXECUTE INSERT_ROOM(45)' and 'EXEC SQL INSERT_ROOM(45)': ORA-00900 INVALID SQL STATEMENT For 'BEGIN INSERT_ROOM(45) END;':
ORA-06550: ERROR LINE 1 CHAR -- PLS-00103: END OCCURRED WHERE ONE OF THE FOLLOWING WERE EXPECTED:
:= . ( % ;

For 'BEGIN INSERT_ROOM(45);':
ORA-06550 : Regards,
Rolf

"TurkBear" <jgreco1_at_mn.rr.com> skrev i melding news:r7pb3u8c3a3rpfdmpjsjjnt2l2j7g4m7t2_at_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 Mon Jan 07 2002 - 08:35:45 CST