RE: [sqr-users] Return a user defined PL/SQL table to Brio?

["Dwight Schrute" <schrute.dwight@hotmail.com>]

Question: Are you referring to SQR or Brio?

If it is SQR, try using EXECUTE instead of BEGIN-SQL.

~DKS


>From: "Kevin Laroche" <bydesign@magma.ca>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: <sqr-users@sqrug.org>
>Subject: [sqr-users] Return a user defined PL/SQL table to Brio?
>Date: Fri, 15 Sep 2006 13:10:36 -0400
>
>Hi to all
>I have a query function in PL/SQL which returns a table composed of a 
>series of
>records of the form (number, text, number, number, text).
>
>I have successfully used PL/SQL procedures to return single values to Brio
>with statements like this
>
>BEGIN-SQL
>BEGIN
>CMS.WORKLOAD.GET_NEW_ASSIGNMENTS($officer, #v_count_new,#v_SE_report2 , 
>#v_IV_report2 );;
>END;;
>END-SQL
>
>Can I return the PL/SQL table values into a Brio Array or a list?
>
>If that is not possible then I guess I could write the table to a temporary 
>table
>and then query it from Brio.
>
>Comments?
>
>Thanks
>
>Kevin LaRoche
>Brio 6, Oracle 8i, Forms 5
>Ottawa, Ontario
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Check the weather nationwide with MSN Search: Try it now!  
http://search.msn.com/results.aspx?q=weather&FORM=WLMTAG


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users