Show SProc results in Data Grid (Toad)
Hi
Need some help please
Have the following SP
CREATE OR REPLACE Procedure sp_validate_A_Field
(
field1 IN VARCHAR2,
isValid OUT VARCHAR2
)
IS
tmp_field1 VARCHAR2(100);
BEGIN
SELECT A_field INTO tmp_field1
FROM table1
WHERE field2 = 'xxx'
AND A_field = Field1;
IF tmp_field1 IS NULL OR tmp_field1 = '' THEN
isValid := '0';
ELSE
isValid := '1';
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
isValid := '0';
WHEN OTHERS THEN
isValid := 'Error';
END;
How do I show the results in the data grid when executing the SP. I can show the results in the DBMS output when executing the following
DECLARE output VARCHAR2(30);BEGIN SP_VALIDATE_POLICY_NUMBER ('myinput', output);DBMS_OUTPUT.PUT_LINE(output);END;