ORA-04044: procedure, function, package, or type is not allowed here

Note:
Tables containing ‘$’ SYMBOL and when ever we use tables like v$session,v$log,v$logfile etc shell script take ‘$’ SYMBOL as shell variables and then while reading script it gives error

Solution:
like

select * from v$session;
select * from v$log;

 we have to use in shell script

select * from v$session;
select * from v$log

  • January 20, 2019 | 25 views
  • Comments