Re: HELP: Pro*C: Dynamic Sql method 4, please help

Gentlemen,

I am the original poster for this thread.

The syntax problem for 'sql_statement' already has been solved.

(It's "BEGIN function_name(:a,:b,:c,:d,:e)".)

But after passing the "prepare statement", a new problem is generated.

That is:

'How to pass "TABLE" data type parameter via descriptor?'

The parameters contain INTEGER,NUMBER,... and TABLE, they also include

IN,IN OUT and OUT.

Unfortunally, the books I have in hand doesn't say any word about this.

Any help is appreciated.

Please!!

Eric Tseng

Eric Tseng wrote:
>
> Hello, my teachers,
>
> I got a problem when porting an EC(Informix) program into PC(Oracle's
> Pro*C).
> That's "what's the syntax for calling packed procedure SQL statement in
> dynamic sql method 4?"
>
> Let me use sample to describe my question.
> In informix case:
> {
> ...
> char sql_statement[255]="EXECUTE PROCEDURE function_name(?,?,?,?,?)";
> ...
> EXEC SQL prepare S for :sql_statement;
> ...
> }
> How about this in Pro*C (oracle)? ( For some reasons,I cannot use host
> variables for those parameters. I need to use 'descriptor'. )
>
> BTW, would you please tell me which Pro*C book describes dynamic SQL
> more detail/better than Pro*C/C++ User's guide?
>
> Thanks for your kindly help.
>
> Eric Tseng
> ps: My email is eric_at_sdit.com.tw. Please reply this via email. Thanks.
Received on Wed Jan 29 1997 - 00:00:00 CET