[sqr-users] PL-SQL Oracle character variable assignment problem

["Howard Thompson" <thompsoh@ohsu.edu>]

I have and SQR program that executes some Oracle PL-SQL that assigns values to 
SQR variables. The numeric variables work fine; the string variables don't seem 
to "bind".
 
Here is a distilled version that shows the error:
BEGIN-PROGRAM

BEGIN-SQL
BEGIN
  $SqrStr := 'Hello, world';;
  #SqrNum := 100;;
END;;
END-SQL

  DISPLAY '$SqrStr:  ' NOLINE
  DISPLAY $SqrStr 

  DISPLAY '#SqrNum:  ' NOLINE
  DISPLAY #SqrNum 

END-PROGRAM


When run, I get this:

Hyperion SQR Server - 8.5.0.0.0.566
Copyright (c) 1994-2006 Hyperion Solutions Corporation.  All Rights Reserved.

$SqrStr:  
#SqrNum:  100.000000




Version info
SQR: Hyperion SQR Server - 8.5.0.0.0.566
SQL*Plus SQL*Plus: Release 9.2.0.7.0 - Production on Fri Jan 5 15:13:18 2007
Oracle: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
            With the Partitioning, OLAP and Oracle Data Mining options
           JServer Release 9.2.0.7.0 - Production

 
 Thanks in advance!


--
Howard Thompson
Senior IS Project Lead
Oregon Health & Science University
thompsoh@ohsu.edu
503-494-5936

"A thing of beauty is a joy forever"
-- John Keats




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