Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. plsql related issue

plsql related issue

Scheduled Pinned Locked Moved Database
helppostgresqloracle
1 Posts 1 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • U Offline
    U Offline
    User 11886269
    wrote on last edited by
    #1

    create or replace FUNCTION Activation2(v_status OUT varchar,v_status1 OUT varchar) returns setof sc_register AS $$ declare begin SELECT st_value into v_status FROM sc_activation_dtls WHERE si_slno = 2; select * from sc_register ; end; $$ LANGUAGE 'plpgsql' VOLATILE aftr writng above plsql functiopn in postgresql pane m getting follwing error function result type must be record because of OUT parameters doest it mean that we cant use output parameter and return statent togather. since my requirement is to get some value of table through output parameters along with records of different table ..in one function only. Thanks

    1 Reply Last reply
    0
    Reply
    • Reply as topic
    Log in to reply
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes


    • Login

    • Don't have an account? Register

    • Login or register to search.
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • World
    • Users
    • Groups