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', 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
Last edited by prakashchakra; 11-17-2007 at 09:41 AM.
Reason: Change in text
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Connect to Remote database through stored procedure i am getting following error
wd IN VARCHAR2(14) :='password',
Reply With Quote
Originally Posted by prakashchakra
Bookmarks