Home -> Usenet -> comp.databases.oracle -> Re: slow PL/SQL function

Re: slow PL/SQL function

From: robertsboyle <member21885_at_dbforums.com>
Date: Thu, 30 Jan 2003 05:02:23 -0500
Message-ID: <2458439.1043920943_at_dbforums.com> 








I don't understand why you need either a procedure or a view for this?
Surely all you need to do is



select  description


from    codes


where  code = &param_code;



If you are running from the web, say jsp, you would have $param_code to
be your ? variable and have it as a bind variable (very important) have
a look at the asktom.oracle.com website for examples of bind variables.



If you posted your table structures + an example output + oracle
version, platform and what exactly you are hoping to do then i may be
able to help you further.



R.


--
Posted via http://dbforums.com


Received on Thu Jan 30 2003 - 11:02:23 CET












Original text of this message