troubleshooting Question

is anyone familiar with TOAD ... How do prompt for a value in ORacle using (TOAD)

Avatar of attachie
attachie asked on
Databases
16 Comments1 Solution2855 ViewsLast Modified:
I am using MS Access with an ODBC connection to ORacle. In Access i am using passthrough query. Thus the sql syntax i am suing is ORacle syntax.

before i converted the sql into ORacle syntax, i was using straight Access syntax. I asked access to prompt me to enter in a date range using the following syntax "  a.date_ordered between dateValue([Enter the Start Date (mm/dd/yyyy):]) AND DateValue( [Enter the End Date (mm/dd/yyyy):])  "

in Oracle i believe the syntax is
" a.date_ordered  between &startdate AND &enddate  "   and this works in sql plus, why doesnt this work in TOAD.

when i use the sql plus syntax i get an error stating  "ODBC call failed not all varialbles bound"

note that only occurs when i add in the syntax "a.date_ordered  between &startdate AND &enddate  "

thank you

Attachie
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 16 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros