| Wrongly compile function in SYS user now problem [message #681274] |
Thu, 02 July 2020 22:02  |
|
|
Hi
I have compile one function ('GET_MAX_NO') in sys user. It's previously compile in particular user account. After compilation of sys user this particular function is blocked. Now I drop this function form sys user and again compile in particular user and grant it.
Now in SQL prompt it is working fine but in Forms 6i it's showing error message.
#JBT User (Already have)
CREATE OR REPLACE FUNCTION "GET_MAX_NO"()
CREATE OR REPLACE PUBLIC SYNONYM GET_MAX_NO FOR GET_MAX_NO;
GRANT ALL ON GET_MAX_NO TO PUBLIC;
#Sys user (I have done wrongly)
CREATE OR REPLACE FUNCTION "GET_MAX_NO"()
CREATE OR REPLACE PUBLIC SYNONYM GET_MAX_NO FOR GET_MAX_NO;
GRANT ALL ON GET_MAX_NO TO PUBLIC;
#Now I drop this function from JBT and Sys user
and newly create in JBT user and grant to all user.
Now when I compile this function in forms 6I it's not compile showing error message.
Regards
Sandip
-
Attachment: data.jpg
(Size: 216.62KB, Downloaded 2387 times)
|
|
|
|
|
|
|
|
| Re: Wrongly compile function in SYS user now problem [message #681278 is a reply to message #681277] |
Fri, 03 July 2020 02:57  |
 |
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Does it work with SQL*Plus.
Copy and paste SQL*Plus session.
Before, Please read How to use [code] tags and make your code easier to read.
More, restart from the beginning dropping all object and recreating them with a SQL*Plus session you will post here.
Check your installation with the following queries (you will copy and paste executions and results):
select owner, object_type, status from dba_objects where object_name = 'GET_MAX_NO';
select owner, table_owner, table_name, db_link from dba_synonyms where synonym_name = 'GET_MAX_NO';
select grantee, owner, table_name from dba_tab_privs where table_name= 'GET_MAX_NO'; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Wrongly compile function in SYS user now problem [message #681287 is a reply to message #681286] |
Fri, 03 July 2020 10:08 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
|
Many sites block attachments. Many/most participants in the forums refuse to download them for the same reason other block them. You've been asked to present your information as text, copied from your sqlplus command session. Refusal to do so is not helping your search for assistance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
