pl sql script

[Hansvb]

Is it Possible to run a PL/SQL script in Lazarus. I use ZEOSLIB components to run sql query's.

[cpalx]

Pl sql and pl pgsql works creat. The easy way todo use it isla lke any query

[Hansvb]

I use TZQuery and want to start the pl sql script with Query.open
This gives an error on the ":=" in the script. (I will post the error later on)

example, this will not work (And works fine i sql developer)

Code: [Select]

declare
  V_test number;
begin
 v_test := 10;
end;
/



[tudi_x]

I think you should try with Query.ExecSQL.
Open is more for datasets.

I would also be cautios about the '/'.

[Hansvb]

The slah "/"  is nessecary. It runs the pl/ sql block

[Hansvb]

I can't get zoes lib to run a simle emtpy test pl/sql block
I use 7.14 stable

pl/sql (This runs fine in sqlplus and TOAD).:

Code: [Select]

declare
  v_test Number;
begin
  NULL;
END;
/   

i get an error on line 1 position 8.
error message: SQL Error: OCI_ERROR: ORA-06550; Line 1, column 8:
PLS-00103: Symbol "" encounterd

when i change de pl/sql code to:

Code: [Select]

declare v_test Number; begin NULL; END; /

then i get the same warning but at line 1 position 22.

So  it seems to me that the return in the first code and "end of line" in the second code is not excepted.

What is wrong?

[miab3]

@Hansvb,

Probably the idea is:
http://sourceforge.net/p/zeoslib/tickets/93/

Correct or use ZEOS 7.2:
http://zeoslib.sourceforge.net/viewtopic.php?f=40&t=3795&p=36341#p36341
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-7.2/

Michal

[Hansvb]

I tried zeos 7.2. Got it from sourceforge yesterday. I installed lazarus compete fresh. I get an acces violation when i start a query. When i replace the zoes component to 7.14 the accea violation is gonne. So it seems i cant install 7.2 right to test the pl/sql

[miab3]

@Hansvb,

I tried zeos 7.2. Got it from sourceforge yesterday. I installed lazarus compete fresh. I get an acces violation when i start a query.

That's weird. 
To me it never happened.
You write about the version downloaded from the address?:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-7.2/

What is your development environment?
(My I list here:
http://zeoslib.sourceforge.net/viewtopic.php?f=40&t=3795&p=36341#p36341)

Michal

[Hansvb]

i got it with:
svn checkout svn://svn.code.sf.net/p/zeoslib/code-0/trunk zeoslib-code-0

it is rev 3561

[Hansvb]

I am still trying to get pl/sql code to work.

At the end of the sql statement i get a warning: "Symbol '''' found.
This warning always shows at the end of a statement.

Code: [Select]

  with DataModule1.ZQuery_Adress do
      begin
        Close;
        SQL.Clear;
        sql.Add('declare v_test Number; begin NULL; END;' + #13#10);
        ExecSQL;
      end;
Without the #13#10 i get the same warning.

[tudi_x]

@Hansvb - do you have a pl/sql script that returns something?

maybe something like a small stored procedure that is called by the pl/sql script so I can see a returned value on the screen.
I am having Zeos 7.1.4 and 11g and could also test.

[Hansvb]

I don't have stored procedures. it is just a pl/sql block wtih no functions to test it.

Code: [Select]

declare
v_test Number;
begin
NULL;  --just for testing
END;
/