Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Missing Mandatory Parameter

Status
Not open for further replies.

LeonelSanchezJr

Programmer
Jan 26, 2001
522
0
0
US
I have a direct SQL Pass in a fex and I get the following error message:

(FOC1400) SQLCODE IS 1009 (HEX: 000003F1)
: ORA-01009: missing mandatory parameter
(FOC1405) SQL PREPARE ERROR.

The query works great in PL/SQL (Oracle), however in the fex, I get this error.

It is 3 UNIONS and if I do the first 2 alone, it works. When I add the 3rd, I get this error. If I run the 3rd part alone, it works fine.

Help....

Thanks,

Leo ;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top