Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL

Re: Dynamic SQL

From: JoeZ53 <joez53_at_aol.com>
Date: 25 Feb 1999 20:39:20 GMT
Message-ID: <19990225153920.13527.00000334@ng-ch1.aol.com> 





Unfortunately, Forms 4.5 only allows you to use PL/SQL version 1.2.  Dynamic
SQL is available with version 2.0.  Therefore, you will have to use a stored
procedure to execute true dynamic code.



However, if you are merely changing the where clause, you can use the PRE-QUERY
trigger to modify the where at run-time.
Received on Thu Feb 25 1999 - 14:39:20 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US