Skip to content

Instantly share code, notes, and snippets.

@velll
Created April 17, 2017 11:24
Show Gist options
  • Save velll/bcfd5363fac108b44b5de7d7a5741be6 to your computer and use it in GitHub Desktop.
Save velll/bcfd5363fac108b44b5de7d7a5741be6 to your computer and use it in GitHub Desktop.
Binding records in plsql — doesnt work obviously
DECLARE
rc_Address SI_ADDRESSES%ROWTYPE;
PROCEDURE DO_IT_WITH_ADDRESS(
rc_Address SI_ADDRESSES%ROWTYPE)
IS
BEGIN
RAISE_APPLICATION_ERROR(-20100, 'Yea, doin'' it with address ' || rc_Address.N_ADDRESS_ID);
END DO_IT_WITH_ADDRESS;
BEGIN
rc_Address.N_ADDRESS_ID := 1;
EXECUTE IMMEDIATE '
BEGIN
DO_IT_WITH_ADDRESS(:address);
END'
USING rc_Address;
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment