RE: Passing Varialbles w/OAS & PL/SQL

Thanks folks,

I got it working. The app is really pretty cool. Just a real bear figuring out everything with no guidance. Lessons I'll never forget - too hard won.

Regards,

David A. Barbour

> -----Original Message-----
> From: David Barbour
> Sent: Tuesday, May 16, 2000 3:48 PM
> To: 'Multiple recipients of list ORACLE-L'
> Subject: Passing Varialbles w/OAS & PL/SQL
>
> Hey Guys and Gals,
>
> Could anyone shed some light on this for me? I'm getting date from a
> form. If the count of the number of orders for the customer equals
> one(1), I execute the following:
>
> OWA_UTIL.REDIRECT_URL('orderreview?tcusnum='||v_customer_number ||
> '&cusord='||NULL);
>
> If there are multiple orders, I place them in an unordered href'd(is that
> a word?)list. Clicking the link sends you to the same place as above.
>
> htp.anchor2('orderreview?tcusnum='||NULL ||
> '&cusord='||v_order_number,htf.listItem(v_order_number));
>
> The procedure orderreview starts out with:
> CREATE OR REPLACE PROCEDURE orderreview(
> TCUSNUM varchar2,
> CUSORD varchar2)
>
> I get the following error for both: OWS-05101: Execution failed due to
> Oracle error -6550 This is NOT a lot of help. The error screen does
> show my parameters passing. It tells me for instance: PARAMETERS:
> =========== TCUSNUM: 05001234567788 CUSORD:
> This part is good, I think. Any ideas?
> Sleepless in Austin
Received on Wed May 17 2000 - 20:31:18 CDT