1

Topic: To receive value from unit PL/SQL

2

Re: To receive value from unit PL/SQL

0694;
You would write, what exactly did not turn out.
Yes, like, and PL/SQL for this request it is not necessary...

3

Re: To receive value from unit PL/SQL

SELECT COUNT (*) cnt
FROM pdm_dpp.a_tech_doc a
WHERE a.id_sum_spec =:id_sum_spec
AND a.v_e = 999999
AND a.tag_a <> 0
GROUP BY a.num_serial
HAVING COUNT (*)> 1

The anonymous unit is not necessary

4

Re: To receive value from unit PL/SQL

ma1tus;
Whether correctly I address to a variable from Oracle Query?
Here this line: oqCount_V.GetVariable (' V_COUNT ')> 0

5

Re: To receive value from unit PL/SQL

ma1tus wrote:

what exactly did not turn out.

Talked nonsense...))
Probably, in DOA somehow so:

begin select * into:x from dual end;

6

Re: To receive value from unit PL/SQL

0694;
Plsql-variable and component parameter - not one and too. Try instead of Declare in plsql, DeclareVariable in delphi...

7

Re: To receive value from unit PL/SQL

0694 wrote:

ma1tus;
Whether correctly I address to a variable from Oracle Query?
Here this line: oqCount_V.GetVariable (' V_COUNT ')> 0

Than did not arrange the simple decision?
It would be desirable strange?

8

Re: To receive value from unit PL/SQL

[quote=0694

"DECLARE
v_count BINARY_INTEGER: = 0;
BEGIN
SELECT COUNT (cnt)
INTO v_count
FROM (SELECT COUNT (*) cnt
FROM pdm_dpp.a_tech_doc a
WHERE a.id_sum_spec =:id_sum_spec
AND a.v_e = 999999
AND a.tag_a <> 0
GROUP BY a.num_serial)
WHERE (cnt)> 1;
:v_count: = v_count;
END;"

So goes?