Hi Everyone,
I'm writing PL/SQL code which utilizes the NTILE function but have just
found out that due to a bug in Oracle8i the function
works from Sqlplus but not when called from PL/SQL.
I've run the following code in Oracle 8i and 9i and the results are given
below.
Unfortunately the database
Look into native dynamic sql -
the standard trick with SQL that pl/sql cannot
handle is to do something like:
declare
cursor variable declaration
begin
open cursor_variable for
'your sql string as a text string'
;
loop
fetch cursor variable into local variables
Just wrap it within 'execute immediate' and it will
run fine.
hth
connor
--- Kieran Murray [EMAIL PROTECTED] wrote:
Hi Everyone,
I'm writing PL/SQL code which utilizes the NTILE
function but have just
found out that due to a bug in Oracle8i the function
works from Sqlplus but not when