1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Pl spl function that returns a nestedtable

Discussion in 'SQL PL/SQL' started by chile, Aug 17, 2017.

  1. chile

    chile Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    South africa
    i would like help with creating a function for login in pl sql that takes in input parameters and then queries four tables and returns the information in form of an array or table that will be sent in json.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,533
    Likes Received:
    362
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    And what is it you want to DO at login? What information is it you think you 'need'? What 'input parameters' are you expecting to populate at login? There are many part of this request that are missing; if you honestly want assistance you need to provide much more than you have now.