Hi All,
Since I am not good at writing pl/sql , but somehow I tried to write anonymous block to make connections in database to check connectivity. I used following code to achieve this , but it seemed , I am missing something here.
would appreciate , if someone would like to offer anything.
SQL> declare
i_statement varchar2(100);
begin
for i in 1..20
loop
i_statement:='conn dbman/welcome3support@robo';
execute immediate i_statement;
end loop;
end;
/ 2 3 4 5 6 7 8 9 10
declare
*
ERROR at line 1:
ORA-00900: invalid SQL statement
ORA-06512: at line 7
Regards