RE: [PHP] Oracle stored procedures

2006-04-06 Thread Jay Blanchard
[snip] I am using PHP with Oracle, but not executing stored procedures. I assume you are already validating the contents of the $addr variable before you bind it? Otherwise, no real ideas here... [/snip] Yes, I am validating the contents of the variable. I have ton some reading, but details a

Re: [PHP] Oracle stored procedures

2006-04-06 Thread Brad Bonkoski
I am using PHP with Oracle, but not executing stored procedures. I assume you are already validating the contents of the $addr variable before you bind it? Otherwise, no real ideas here... -B Jay Blanchard wrote: [snip] I have a stored procedure in Oracle; p_BILL_TO_ADDRESS1 IN C

RE: [PHP] Oracle stored procedures

2006-04-06 Thread Jay Blanchard
[snip] I have a stored procedure in Oracle; p_BILL_TO_ADDRESS1 IN CONT_ADDRESS.ADDRESS1%TYPE Default NULL, --VC(50) With a condition; IF p_BILL_TO_ADDRESS1 is NULL THEN Raise_Application_Error(-20100,'BILL TO Address cannot be a NULL Value'); END IF; I have some PHP code that tri

[PHP] Oracle stored procedures

2006-04-05 Thread Jay Blanchard
Howdy group... I have a stored procedure in Oracle; p_BILL_TO_ADDRESS1 IN CONT_ADDRESS.ADDRESS1%TYPE Default NULL, --VC(50) With a condition; IF p_BILL_TO_ADDRESS1 is NULL THEN Raise_Application_Error(-20100,'BILL TO Address cannot be a NULL Value'); END IF; I have some PHP code