Search found 1 match

by OdacPgdac
Mon 16 Aug 2021 13:00
Forum: PostgreSQL Data Access Components
Topic: Migration from Oracle to PG
Replies: 1
Views: 14848

Migration from Oracle to PG

odac
component TOraSQL

Code: Select all

begin
  :param1 := 5;
end;
after execution i can get result of out parameter

Code: Select all

OraSQL->ParamByName("param1")->AsInteger;
pgdac
component TPgSQL

Code: Select all

DO $$
BEGIN
  :param1 := 5;
END $$;
after execution i get error "syntax error at or near ":""
how to use out parameter in pg?