INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...your web site's great! I've been using this system for almost a year now and find it really, really helpful. The people have been helpful in answering just about any question you post in the forums..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Web Development > Information Builders, Inc.: WebFOCUS Forum

Missing Mandatory Parameter

Read More Threads Like This One

LeonelSanchezJr (Programmer)

2 Dec 05 17:30

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Information Builders, Inc.: WebFOCUS