Hi,

I have to call a Oracle store procedure in WebFOCUS procedure(fex file). I am googling the result how to call the SQL sever store procedure, but did not find how to call the Oracle store procedure.

I could execute the Oracle store procedure in Oracle SQL Developer like this:
begin
SL_NO_INCEDENT('185', '185', 'EDIT');
end;

I've tried
SQL EX SL_NO_INCEDENT('185', '185', 'EDIT');
but it is not working.

do not worry about the input parameters,any help on this?

Thanks!

2013-01-09 update:
Question answered by MattC.

This message has been edited. Last edited by: Pippen,

This is what I use to call an Oracle procedure

SQL
CALL SCHEMA.PROCEDURE();
-RUN
  

It works fine for me.

I have used this syntax in the past:

 
-SET &QUALIFIER   = &DB_OWNER_ID |'.'| &DB_PACKAGE |'.';

ENGINE SQLORA SET DEFAULT_CONNECTION &CONNECTION_NAME
SQL SQLORA EX &QUALIFIER.storedprocedure_name ¶meter ;
 

quote:

Originally posted by MattC:
This is what I use to call an Oracle procedure

SQL
CALL SCHEMA.PROCEDURE();
-RUN
  

It works fine for me.

Hi MattC,

Thanks for the answer, it works for me !
by the way, I have to mention the agent name SQLORA after SQL, so all my execute script would be like this:

 
ENGINE SQLORA SET DEFAULT_CONNECTION conntion_name
SQL SQLORA
CALL MY_SCHEMA_NAME.SL_NO_INCEDENT(160, 160, 'EDIT');
END 

Question closed.
Thanks again.

We use an -INCLUDE that has the connection string that has the SQLORA in there. That way we don't have to change in several places in each procedure.

Glad it works!