Connect to Remote database through stored procedure i am getting following error

Hi,

Please find the code which i written to connect remote database :

create or replace PROCEDURE REMOTE_CONNECT( :idb IN VARCHAR2(14) :='PROD',
:dbname IN VARCHAR2(14) :='PROD',
:uid IN VARCHAR2(14) :='user',
:pwd IN VARCHAR2(14) :='password',
SQLCODE)
IS


BEGIN


connect to :dbid AS :dbname USER :uid USING :pwd;


dbms_output.put_line('connected to database');
END;

I am getting following error :

ORA-SQL-PLSQL S1982

(S1982) Expecting Identifier

The alert message which i get at the time of compilation is :

NO CREATE[OR REPLACE] statement found to execute.


Please know why i am getting the following error message. Is the above cod e to be modified ? Please guide me

What are you trying to do?

every single line you have written is a load of rubbish, do you not know anyone who knows about oracle to help you?

Can i have connect statement to remote database in a stored procedure ?

Quote:

---

Originally Posted by prakashchakra

Can i have connect statement to remote database in a stored procedure ?

---

Huh? :confused:

Quote:

---

Originally Posted by prakashchakra

Can i have connect statement to remote database in a stored procedure ?

---

do you know anything about oracle? what are you trying to do here