Custom Object Types

From: Dom (dom_at_nospam.it)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 10:11:28 GMT

Hi to all,
I have a PLSQL package containing 2 methods: get_account and set_account.
The former returns an Account type, the latter accepts an Account type.
Account TYPE is defined as %ROWTYPE of an Account Table contained inside DB.

This is the PLSQL package:
CREATE OR REPLACE PACKAGE test AS
    SUBTYPE Account IS MEMBERSHIP.ACCOUNT%ROWTYPE;

    PROCEDURE get_account (
    p_username VARCHAR2,
    p_password VARCHAR2,
    p_account OUT Account,
    return_code OUT NUMBER);

    PROCEDURE set_account (
    p_account IN Account,
    return_code OUT NUMBER);
END;
/

Now I want to call these 2 procedures from a java program via a callable
statement....
what is the best approach to deal with Account type?
I have a Java Bean Account.java describing Account type....
I have read that there are 2 approaches: one based on oracle.sql.STRUCT and
the other based on java.sql.SQLData....
If my Account.java also implements java.sql.SQLData, does not match JavaBean
pattern anymore?

Thanks for any advice, link and code examples

Dom

Relevant Pages

  • Re: Admin verses Limited Account In Outlook Express
    ... The reason I am asking is because, if I set this user id to have an account ... type of administrator I have absolutely no problem opening mail, ... same user id to have an account type of Limited, then I get all those error ... > message that was downloaded in Outlook Express. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Query is not fast
    ... How could you possibly do be doing a grouping and sorting on that data as ... 000100000042xxx Account Maintenance ... Thus we want to have the above two columns, then you can do a query to Group ... by each account type, and we'll be able to use high speed indexing for this ...
    (microsoft.public.access.queries)
  • Re: Admin verses Limited Account In Outlook Express
    ... The reason I am asking is because, if I set this user id to have an account ... type of administrator I have absolutely no problem opening mail, ... same user id to have an account type of Limited, then I get all those error ... When I click a message to open it it says "Outlook Express is incorrectly ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Outlook error on dialup
    ... This is not usually an Outlook problem. ... so we now know the mail account type SMTP/POP3. ... >>Russ Valentine ...
    (microsoft.public.outlook.general)
  • Re: I bought a new computer yesterday... it came with VISTA !!
    ... is the default account type in Vista, ... that that means I'm running as an Admin. ... without a member of the Administrator group typing their password. ...
    (comp.sys.mac.advocacy)