The previous version 1.0 version is still available as reference, in PEP 248. The expression validates and returns a boolean value. This document describes the Python Database API Specification 2.0 and a set of common optional extensions. You can define multiple SQL queries in a single data set, but only one query executes at run time depending on the expression value. This name is reserved for out variable type for procedure/anonymous blocks.Ĭonditional queries can be executed if you use an if-else expression. If you do not declare the name properly, the first bind variable is treated as an out variable type and binds with REF cursorĭeclare the data model parameter with name xdo_cursor. You must declare the out variable with the name, xdo_cursor. The PL/SQL block must return a result set of type REF cursor BI Publisher uses callable statements to execute anonymous blocks. You can perform calculations in the PL/SQL block and return the result set. To use REF cursor in Oracle BI Publisher:Ĭreate SQL dataset with query as SELECT REF_CURSOR_TEST.GET(:PCNTRY,:PSTATE) AS CURDATA FROM DUALīI Publisher supports executing PL/SQL anonymous blocks. SELECT TO_CHAR(sysdate,'MM-DD-YYYY') CURRENT_DATE , Use this query type to issue SQL statements that can include the following:Ĭursor statements that return nested results setsĮx:SELECT TO_CHAR(sysdate,'MM-DD-YYYY') CURRENT_DATE ,Ĭreate or replace PACKAGE REF_CURSOR_TEST ASįUNCTION GET( pCountry IN VARCHAR2, pState IN VARCHAR2) RETURN REF_CURSOR_TEST.refcursor Ĭreate or replace PACKAGE BODY REF_CURSOR_TEST AS