Re: Execute a stored procedure from OCI

1. Wrap your statement in an anonymous block as in example number 3.
2. Bind your statement parameters.

Post full example with code (OCI, Stored Proc) and errors and I would be happy to give it a look-see.

Hth,

~Cliff

"Rolf C Stadheim" <r-stadhe_at_online.no> wrote in message news:zmlZ7.18743$KQ3.298865_at_news1.oke.nextra.no...
> 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
>
>
Received on Fri Jan 04 2002 - 16:04:45 CST