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

[prakashchakra]

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',
wd IN VARCHAR2(14) :='password',
SQLCODE)
IS


BEGIN


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


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