This content has been marked as final. Show 3 replies
What exactly have to written in your statement. Also, if possible, it would be much easier to create a databaselink to the source-database and then use "plain" sql.
Yes, i am using Plan Sql as i have created heterogenous connectin between Oracle and MYsql.
I can select,insert data also copy data from Sql*Plus.
But My question is that, I want to Use Copy command through Forms.
If it is possible then plz tell me.
Dear Kami Lily,
Oracle Forms is able to execute SQL and PL/SQL command only. Additionally it supports Operating System command by HOST built-in.
Though COPY is a SQL*Plus command, it is not possible to execute this command by HOST built-in.
Instead, if you hardly want to execute COPY command oracle forms 6i, then you make a batch file in operating system and run that batch file from HOST built-in.