[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR 8.5 Oracle Stored Proceure Output Parameter
- Subject: [sqr-users] SQR 8.5 Oracle Stored Proceure Output Parameter
- From: Pete Andrusyszyn <andrusp@oneonta.edu>
- Date: Wed, 1 Aug 2007 10:36:16 -0400
- Delivery-date: Wed, 01 Aug 2007 10:38:34 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
We are testing SQR 8.5 and have come across a problem calling oracle
stored procedures that have an out parameter. The output is being
truncated at 1 character.
e.g.
begin-sql
begin
myprocedure($out_param);;
end;;
end-sql
The value returned by myprocedure into $out_param is truncated at 1
character. It works fine in sqr 8.3.1. Any thoughts? We are running
against an Oracle 10gR2 database.
Thanks
-Pete
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users