I am using database version 10.1.0.2.0 and Forms 6i, I need some help regarding this problem, I have a database user these privileges
create session
create table
create view
create procedure
create synonym
create trigger
create sequence
unlimited tablespace
Whenever and wherever I use DUAL table in my application it gives me error
Example:
select sys_context('USERENV', 'IP_ADDRESS') from dual;
Please help me to solve this problem on permanent basis furthermore when I execute this statement in SQL it executes successfully I also try to execute this statement in SCOTT user but the problem is same.
Your urgent and positive reply will be highly appreciated.
Bookmarks