Oracle 8.1.7 Stored Procedure and passing date parameters 1

[hallux]

Hi everybody,
I have created a stored procedure and it works fine in PL/SQL Developer returning the cursor. In PL/SQL Developer it only requests the date "7/2/03", but in Crystal 8.5 Dev it asks for both the date and time. Is there any way to only have CR request the date and not the time? I am sure others have hit this situation, what are my options?
-Hallux

 

[synapsevampire]

I think that Oracle only has a data type of Date, which includes the time, so Crystal will prompt accordingly.

Yo cannot alter a Stored Procedures parameter type from within Crystal, if you had a View you could.

-k

 

[hallux]

Thanks,
It helps to know I couldn't change the date/time parameter. After further testing, the problem ended up with Crystal when I didn't uncheck the "Set to NULL value" checkbox for the parameters.
-Hallux