0 Replies Latest reply: Jan 28, 2009 7:05 AM by 302084 RSS

    Forms personalization and global variable

    302084
      Hi,
      I'm trying to call a procedure in forms personalization and using a defined global variable. The data in the global variable is number. In the procedure, some of the parameter has a number datatype and I'm converting the global variable using to_number eg (to_number(:global.XX_LINE_NUM). This fails with error message ora-01403 no data found. I've tried putting the above into a variable with datatype number in the declare statement, and it errors as well.
      Does anyone knows the syntax to convert the global variable to number datatype in personalization.
      Thanks