ATTACH SOURCE Oracle Lite [message #57469] |
Tue, 17 June 2003 15:45 |
rickster
Messages: 1 Registered: June 2003
|
Junior Member |
|
|
I have a class called Get_Emp in the same directory as the default database.
When I run this line in SQL pLus 3.3.3.0.0
ALTER TABLE EMP ATTACH SOURCE 'Get_EMP' IN 'C:ORANTPOLDB';
/
I continually get a syntax error
OCA-30021: error preparing/executing SQL statement
[[POL-5228]] syntax error
And this way
ALTER TABLE EMP ATTACH SOURCE 'Get_EMP' IN '.';
/
And this way
ALTER TABLE EMP ATTACH JAVA SOURCE 'Get_EMP' IN 'C:ORANTPOLDB';
/
I have tried double quotes as well.
Alter Table Add .... works fine
Simple thing I know but I am a fledgling.
|
|
|