Re: Help with dynamic PL/SQL using dbms_sql
From: Robert Gauf <75301.2763_at_CompuServe.COM>
Date: 1995/06/15
Message-ID: <3rocif$6g9$1_at_mhafc.production.compuserve.com>#1/1
Date: 1995/06/15
Message-ID: <3rocif$6g9$1_at_mhafc.production.compuserve.com>#1/1
Tommy
I too thought that a functin would be great, as in
SELECT fiscal_year_end(date_field) FROM fiscal_info_table;
but if you look closely in the appropriate manual (I don't
remember which one) you'll find that it says that you can only
put user-defined functions into PL/SQL, NOT into plain SQL !!!
If anyone knows a way around this could you help both of us?!
tia.
Rob
I'm not so sure about your dynamic SQL error but...
--
Rob Gauf ph 403-930-6164
I.S. Research & Technology The Brick Warehouse (Canada)
Received on Thu Jun 15 1995 - 00:00:00 CEST