Bonjour;

J'ai une erreur oracle en essayant de créer un objet directory :

ERROR at line 3:
ORA-06550: line 3, column 11:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue.
ORA-06550: line 8, column 1:
PLS-00103: Encountered the symbol "PROMPT" when expecting one of the following: := . ( @ % ;
Le code sql :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
DECLARE 
directory varchar2(100);
directory := '/var/tmp/test';
BEGIN
 
CREATE OR REPLACE DIRECTORY REPERTOIRE AS directory;
GRANT READ, WRITE ON DIRECTORY REPERTOIRE TO monschema; 
END;
/
spool off
Merci