Home » Developer & Programmer » Forms » SET CURRENT_SCHEMA='SYSTEM' problem
SET CURRENT_SCHEMA='SYSTEM' problem [message #212339] Thu, 04 January 2007 15:39 Go to next message
wael890610
Messages: 17
Registered: June 2005
Location: Egypt-Ismaelia
Junior Member

when i am traying to execute ALTER SESSION SET CURRENT_SCHEMA='SYSTEM',i receive the error ORA-02421 missing or invalid schema authorization identifier.
Re: SET CURRENT_SCHEMA='SYSTEM' problem [message #212437 is a reply to message #212339] Fri, 05 January 2007 05:19 Go to previous messageGo to next message
aditya_gangadharam
Messages: 43
Registered: February 2005
Location: Hyderabad
Member

hi,

i think so you dont have the all DBA privilages.

make sure that you have all the DBA privilages




regards,
aditya.
Re: SET CURRENT_SCHEMA='SYSTEM' problem [message #212443 is a reply to message #212339] Fri, 05 January 2007 05:37 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have a look at http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7483411948917

David
Re: SET CURRENT_SCHEMA='SYSTEM' problem [message #212507 is a reply to message #212339] Fri, 05 January 2007 10:53 Go to previous messageGo to next message
wael890610
Messages: 17
Registered: June 2005
Location: Egypt-Ismaelia
Junior Member

thnx
Urgent help [message #212531 is a reply to message #212437] Fri, 05 January 2007 12:47 Go to previous messageGo to next message
pavansite
Messages: 2
Registered: January 2007
Location: HYDERABAD
Junior Member

HI Friends,

i am getting problem while creating below cursor,
please help me

ALTER PROCEDURE dbo.rspGetTimeZoneUpdate
AS

DECLARE @@AreaCode VARCHAR(3),
@@TimeZoneID VARCHAR(1)
DECLARE TZCursor CURSOR local Scroll Keyset Optimistic
FOR
SELECT
AreaCode,
TimeZone
FROM LeadsManagement.dbo.TimeZone

OPEN TZCursor
PRINT 'hi'

FETCH Absolute 1 FROM TZCursor INTO
@@AreaCode,
@@TimeZoneID
PRINT @@AreaCode
PRINT @@TimeZoneID

WHILE @@fetch_Status<>0
begin

FETCH NEXT FROM TZCursor
INTO @@AreaCode,@@TimeZoneID

-- -- Get a record and populate the variables


UPDATE LeadsManagement.dbo.LeadsMaster
SET TIMEZONE = @@TimeZoneID
WHERE LEFT(phone,3) = @@AreaCode
PRINT @@AreaCode
PRINT 'bye'

CLOSE TZCursor
DEALLOCATE TZCursor

END


Thanks
Pavan
Re: Urgent help [message #212537 is a reply to message #212531] Fri, 05 January 2007 13:33 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@Pavan: this isn't Oracle.

It is Oracle forum, and your code seems to be something different.
Previous Topic: Quiet commit on a form
Next Topic: forms problem !
Goto Forum:
  


Current Time: Tue Dec 03 17:37:26 CST 2024