Help, forming dynamic query in PL/SQL proc. using parameters
Date: 1996/09/06
Message-ID: <11610_at_842032456>#1/1
I am working on a project that involves Oracle WebServer 2.0 and Netscape. I
encountered the following PL/SQL problem :
*I tried to pass two variables: signs and mydate from the netscape form
to the stored procedure. The I would like to use the follow:
cursor c1 is select * from table1 where tbdate signs mydate;
I understand that the parser will expect one of the signs such as >, = ,<
instead of a variable in the place of the signs. I wonder if any of you
knows how to get around with this
Any help is greatly appreciated. Thanks!
Xing Chun Zheng
xczheng_at_cs.indiana.edu
--
=======================================================
Xingchun Zheng
xczheng_at_cs.indiana.edu
url: http://www.cs.indiana.edu/hyplan/xczheng.html
Received on Fri Sep 06 1996 - 00:00:00 CEST