Skip to Content
0
Former Member
May 16, 2008 at 08:09 AM

Problem with oracle packages CREATE PACKAGE<some packagename> in MaxDB

18 Views

Hi All,

I am having Problems in Creating Packages from MaxDB ..Does MaxDB supports the CREATE PACKAGE <some packagename>concept ? if so please help me how to achieve in creating packages ..

My sample Oracle package Creation is as follows:

CREATE OR REPLACE PACKAGE BODY acs

AS

FUNCTION add_user (

user_id IN users.user_id%TYPE DEFAULT NULL,

object_type IN acs_objects.object_type%TYPE DEFAULT 'user',

creation_date IN acs_objects.creation_date%TYPE DEFAULT sysdate,

creation_user IN acs_objects.creation_user%TYPE DEFAULT NULL,

creation_ip IN acs_objects.creation_ip%TYPE DEFAULT NULL,

...

) RETURN users.user_id%TYPE

IS

v_user_id users.user_id%TYPE;

v_rel_id membership_rels.rel_id%TYPE;

BEGIN

v_user_id := acs_user.new (user_id, object_type, creation_date,

creation_user, creation_ip, email, ...

RETURN v_user_id;

END;

END acs;

/

show errors Can you Please Explain me how to write the same Package in MaxDB?

Thanks & Regards,

Shanmukh

Edited by: shanmukh babu on May 16, 2008 10:11 AM