1
Using Sqlserver it is possible to run the following two queries within the same firedac Fdquery
FDQuery.FetchOptions.AutoClose := False;
FDQuery.sql.add('select * from tabela1');
FDQuery.sql.add('select * from tabela2');
FDQuery.open;
MemTable1.Data := FDQuery.Data;
FDQuery.NextRecordSet();
MemTable2.Data := FDQuery.Data;
All right on Sqlserver but, someone knows how to run on Oracle?
Executing in this way:
begin
select * from usuario;
select * from mercadoria;
end;
this error occurs:
---------------------------
[FireDAC][Phys][Ora] ORA-06550: linha 2, coluna 3:
PLS-00428: an INTO clause is expected in this SELECT statement
ORA-06550: linha 3, coluna 3:
PLS-00428: an INTO clause is expected in this SELECT statement.
---------------------------
in this way:
select * from usuario;
select * from mercadoria;
this Error occurs:
Running the way it is, some trouble?
– Jefferson Rudolf
Yes. In the documentation there is a quote for execution on Oracle stating that it needs to be executed with anonymous block but the simple block with Begin "commands"; end; is not recognized.
– RONDINELI MARTINS
Put a ; behind each select and run to see. Fdquery.sql.add('select * from Tabela1;'); Fdquery.sql.add('select * from table2;');
– Jefferson Rudolf
I already tried! Invalid character error.
– RONDINELI MARTINS
Question: what is the problem when it comes to consulting
– Jefferson Rudolf
I edited with errors!
– RONDINELI MARTINS