Calling stored procedure from Pro C

[mahesh_575]

EXEC SQL EXECUTE
BEGIN Y001.b0002(ortal_id, :cust_sup_id, :bill_num, :check_flag, :last_upd_date, :unyou_date, :goui_riyuu, :last_upd_person, :touroku_date, :err_code, :err_log);
END;
END-EXEC;

Here b0002 is stored procedure in package Y001.
I am getting Semantic Error to Begin statement.
Can anyone help me please.

[CornedBee]

what language is that?????

[mahesh_575]

CornedBee

I have mentioned it in subject. Calling stored procedures from Pro C.

Can you tell me that how to call a stored procedure from C program. I know that the following block is used but it is giving error that procedure name is not defined.

EXEC SQL EXECUTE
BEGIN
proc-name(param1, param2, ------- );
END;
END-EXEC;

[jim mcnamara]

IT's embedded pl/sql in embedded sql in Pro-C.

The reason is because you can't access the function.

I looked in Oracle 7.3 documentation - which you have to have if you have Pro-C. ALL of this stuff is in there.

Spend some time with the doc set. I do not use pl/sql except on alternate Thursdays in months that end with 'Q'.