Home » SQL & PL/SQL » SQL & PL/SQL » Urgent-Conn statment in PL/SQL
Urgent-Conn statment in PL/SQL [message #41225] Wed, 11 December 2002 05:14 Go to next message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hai,

Can I use conn statment in procedure or function?

How to use it?

Please clarify it.

With Regards,
Balamurugan.R

Report message to a moderator

Re: Urgent-Conn statment in PL/SQL [message #41229 is a reply to message #41225] Wed, 11 December 2002 07:00 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what is a "conn" statement??
you mean connecting as other user?
If so, U cannt.
connect user/pass is an sqlplus command.
instead,
grant required privs and
query the object like
select columnName from schemaname.tablename;

Report message to a moderator

Previous Topic: trigger syntax problem :
Next Topic: error creating a user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 04:59:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.