Home » RDBMS Server » Server Administration » Wrongly compile function in SYS user now problem (Oracle Forms 6i)
Wrongly compile function in SYS user now problem [message #681274] Thu, 02 July 2020 22:02 Go to next message
somu4
Messages: 8
Registered: January 2007
Location: KOLKATA
Junior Member

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 200 times)
Re: Wrongly compile function in SYS user now problem [message #681275 is a reply to message #681274] Fri, 03 July 2020 00:01 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You also have to drop and recreate the synonym from the correct user.

And you should NEVER use, and so connect to, SYS unless you want to manage the database (database does NOT mean its content but its structure and physical life).

Re: Wrongly compile function in SYS user now problem [message #681277 is a reply to message #681275] Fri, 03 July 2020 01:28 Go to previous messageGo to next message
somu4
Messages: 8
Registered: January 2007
Location: KOLKATA
Junior Member

From Sys and JBT users I drop function and synonym.
Again I create function and synonym in JBT user.

Create a Grant to all user.

But Oracle forms 6i it is not working. showing errors.
Re: Wrongly compile function in SYS user now problem [message #681278 is a reply to message #681277] Fri, 03 July 2020 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
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 #681280 is a reply to message #681278] Fri, 03 July 2020 03:29 Go to previous messageGo to next message
somu4
Messages: 8
Registered: January 2007
Location: KOLKATA
Junior Member

/foru/forum/fa/14350/0/
  • Attachment: 1.jpg
    (Size: 146.44KB, Downloaded 188 times)
Re: Wrongly compile function in SYS user now problem [message #681281 is a reply to message #681280] Fri, 03 July 2020 03:31 Go to previous messageGo to next message
somu4
Messages: 8
Registered: January 2007
Location: KOLKATA
Junior Member

/foru/forum/fa/14351/0/
  • Attachment: 2.jpg
    (Size: 145.03KB, Downloaded 194 times)
Re: Wrongly compile function in SYS user now problem [message #681282 is a reply to message #681281] Fri, 03 July 2020 03:32 Go to previous messageGo to next message
somu4
Messages: 8
Registered: January 2007
Location: KOLKATA
Junior Member

/foru/forum/fa/14352/0/
  • Attachment: 3.jpg
    (Size: 221.46KB, Downloaded 196 times)
Re: Wrongly compile function in SYS user now problem [message #681283 is a reply to message #681282] Fri, 03 July 2020 03:36 Go to previous messageGo to next message
somu4
Messages: 8
Registered: January 2007
Location: KOLKATA
Junior Member

SELECT OWNER, TABLE_OWNER, TABLE_NAME, DB_LINK FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'GET_MAX_NO';

/foru/forum/fa/14353/0/
  • Attachment: 2.jpg
    (Size: 145.32KB, Downloaded 189 times)
Re: Wrongly compile function in SYS user now problem [message #681284 is a reply to message #681283] Fri, 03 July 2020 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I don't download images.
Post it as text inside the post and formatted.

Re: Wrongly compile function in SYS user now problem [message #681286 is a reply to message #681284] Fri, 03 July 2020 05:44 Go to previous messageGo to next message
somu4
Messages: 8
Registered: January 2007
Location: KOLKATA
Junior Member

[img]/foru/forum/fa/14354/0/[/img]
  • Attachment: 1.jpg
    (Size: 146.44KB, Downloaded 185 times)
Re: Wrongly compile function in SYS user now problem [message #681287 is a reply to message #681286] Fri, 03 July 2020 10:08 Go to previous message
EdStevens
Messages: 1285
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.
Previous Topic: DBA practice on cloud
Next Topic: Oracle Data Mining component in 19c
Goto Forum:
  


Current Time: Mon Nov 30 16:43:59 CST 2020