The following Oracle script works in JavaScript and in SQL worksheet but fails in the SQL section of the database reader.
select s.supplykey,Supplytradename,Supplygenericname from supply s,supplypo p, cabinet c, dt d, ctrlr t where s.supplykey=p.supplykey and p.cabinetkey=c.cabinetkey and t.cabinetkey =c.cabinetkey and t.dtkey=d.dtkey and p.controllerkey =t.controllerkey and p.spquantity < p.spminimumquantity and d.dtkey in ( select dtkey from dt where nodename like 'MS%');
I even cut out the part in Parens. Tried the script below and I get unknown character errors. Oracle ORA-00911:invalid character errors for both messages.
select s.supplykey,Supplytradename,Supplygenericname from supply s,supplypo p, cabinet c, dt d, ctrlr t where s.supplykey=p.supplykey and p.cabinetkey=c.cabinetkey and t.cabinetkey =c.cabinetkey and t.dtkey=d.dtkey and p.controllerkey =t.controllerkey and p.spquantity < p.spminimumquantity and d.dtkey ;
The first script normally generates multiple rows. I want to take each row and write it out to a file with delimiters (File Writer) in between efficiently.
select s.supplykey,Supplytradename,Supplygenericname from supply s,supplypo p, cabinet c, dt d, ctrlr t where s.supplykey=p.supplykey and p.cabinetkey=c.cabinetkey and t.cabinetkey =c.cabinetkey and t.dtkey=d.dtkey and p.controllerkey =t.controllerkey and p.spquantity < p.spminimumquantity and d.dtkey in ( select dtkey from dt where nodename like 'MS%');
I even cut out the part in Parens. Tried the script below and I get unknown character errors. Oracle ORA-00911:invalid character errors for both messages.
select s.supplykey,Supplytradename,Supplygenericname from supply s,supplypo p, cabinet c, dt d, ctrlr t where s.supplykey=p.supplykey and p.cabinetkey=c.cabinetkey and t.cabinetkey =c.cabinetkey and t.dtkey=d.dtkey and p.controllerkey =t.controllerkey and p.spquantity < p.spminimumquantity and d.dtkey ;
The first script normally generates multiple rows. I want to take each row and write it out to a file with delimiters (File Writer) in between efficiently.
Database Reader script fails, works in javascript
0 commentaires:
Enregistrer un commentaire