Versions Compared

Old Version 9

changes.mady.by.user PSMON

Saved on

compared with

New Version 10

changes.mady.by.user PSMON

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themeEmacs
CREATE OR REPLACE FUNCTION addaddress(
	address character varying,
	age integer,	
	name character varying,
	sex character varying,
	phonenbr character varying, 
	OUT res int)
 
RETURNS integer AS $BODY$
	
	DECLARE
		address_id int;
	BEGIN 
		-- insert address
		
		INSERT INTO address ( address, age, name,sex,phonenbr) VALUES( address, age, name,sex,phonenbr);

		SELECT nextval('address_id') INTO resreturn 0;
		--set res = address_id;		
 
	END; 
$BODY$
LANGUAGE plpgsql VOLATILE


more info: http://roufid.com/3-ways-to-call-a-stored-procedure-with-hibernate-jpa-2-1/