Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    121

    Question Unanswered: Passing Parameters from Forms to reports

    I have a list item which is based on a LOV. When passing the selected list item to Oracle reports I get the following oracle error...
    ORA-06502: PL/SQL: numeric or value error string

    I understand why I am getting this error. However, because this list item is based on a lov, I'm not sure how to force the list item to convert it to a number to accomodate the parameter below....

    add_parameter(param_periph, 'p_request_phys', TEXT_PARAMETER, GET_LIST_ELEMENT_VALUE('lst_phys', :lst_phys));

    Should I use some other type of built-in besides
    GET_LIST_ELEMENT_VALUE ????

  2. #2
    Join Date
    Aug 2002
    Posts
    121
    Please disregard my previous question. I managed to figure it out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •