Passing Varialbles w/OAS & PL/SQL

Here I sit, broken-hearted......

        (It's the reference to "passing" that got to me. Sorry, this problem is driving me up a wall!)

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 Tue May 16 2000 - 15:39:09 CDT