How to pass "Null" vaule to a parameter via URL?

[chenkang]

Hello, All

We have crystal reports running on Oracle 8i stored procedures, We use "CR Oracle 8 ODBC Driver" and everything follows document "scr_oracle_stored_procedures.pdf"(ie. first parameter is a in/out ref cursor parameters). We do web distribution by passing value to those parameters via URL.

With "CR Oracle 8 ODBC Driver", the CR viewer will not ask value for the first parameter(in/out refcursor), everything works fine. However, since we are going to upgrade database server to Oracle 9i, we may need to change driver to "Oracle Native Driver" or some other ODBC drivers. For "Oracle Native Driver", CR viewer will ask value for the first parameter in stored procedure, which should be NULL. Does anyone know how to pass NULL value to a parameter via URL without pop up the prompt window?

Thanks a lot.

Kang

 

[lynnd]

Did you ever get this situation resolved?

 

[chenkang]

No. we haven't figured it out yet. Do you have any idea?

 

[lynnd]

I think you can pass nothing through the URL as in:

http://<servername>/reportname.rpt?user0=user&password0=pwd&prompt0=&prompt1=value...

etc.

I have done this using the Native Oracle driver (we have Oracle 8.1) and it works; I don't know about 9...

Let me know if that works for you, or what else you have tried.
Lynn