OraFAQ Forum: Forms » SET CURRENT_SCHEMA='SYSTEM' problem

Home » Developer & Programmer » Forms » SET CURRENT_SCHEMA='SYSTEM' problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SET CURRENT_SCHEMA='SYSTEM' problem [message #212339]

Thu, 04 January 2007 15:39

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.

Report message to a moderator

Re: SET CURRENT_SCHEMA='SYSTEM' problem [message #212437 is a reply to message #212339]

Fri, 05 January 2007 05:19

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.

Report message to a moderator

Re: SET CURRENT_SCHEMA='SYSTEM' problem [message #212443 is a reply to message #212339]

Fri, 05 January 2007 05:37

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

Report message to a moderator

Re: SET CURRENT_SCHEMA='SYSTEM' problem [message #212507 is a reply to message #212339]

Fri, 05 January 2007 10:53

wael890610
Messages: 17
Registered: June 2005
Location: Egypt-Ismaelia

Junior Member

thnx

Report message to a moderator

Urgent help [message #212531 is a reply to message #212437]

Fri, 05 January 2007 12:47

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

Report message to a moderator

Re: Urgent help [message #212537 is a reply to message #212531]

Fri, 05 January 2007 13:33

Littlefoot
Messages: 21825
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.

Report message to a moderator

Previous Topic:	Quiet commit on a form
Next Topic:	forms problem !

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 09 10:30:12 CDT 2025