Hi,
I have created stored procedure in db....
I want to execute stored procedure in direct database request in analytics..
When i trying , i am getting errors..
my stored procedure is
CREATE OR REPLACE PROCEDURE TESTINGPROCEDURE(OutCur OUT sys_refcursor)
AS
BEGIN
OPEN OutCur FOR
select * from w_company_d
END;
execution:
var rc refcursor
exec testingprocedure(:rc)
print rc
Please help me..
in direct database request of obiee 11g analyics, how to call this procedure..
I have tried.. i have enter connection pool name..
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 17001] Oracle Error code: 900, message: ORA-00900: invalid SQL statement at OCI call OCIStmtExecute: var rc refcursor exec testingprocedure(:rc) print rc. [nQSError: 17011] SQL statement execution failed. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "r2_conn_pool" var rc refcursor exec testingprocedure(:rc) print rc')}