To create the package and procedure in Oracle SQL, you can follow the steps below:

Step 1: Create the package specification. This is like a function prototype in C/C++. It declares the types, variables, constants, exceptions, cursors, and subprograms available for use.

```sql
CREATE OR REPLACE PACKAGE pkg_customer AS
PROCEDURE addCustomer(
c_id t_customer.cust_id%type,
c_name t_customer.cust_name%type,
c_addr t_customer.cust_address%type
);
END pkg_customer;
/
```

Step 2: Create the package body. This is where you define the procedures and functions that were declared in the package specification.

```sql
CREATE OR REPLACE PACKAGE BODY pkg_customer AS
PROCEDURE addCustomer(
c_id t_customer.cust_id%type,
c_name t_customer.cust_name%type,
c_addr t_customer.cust_address%type
) IS
BEGIN
INSERT INTO t_customer (cust_id, cust_name, cust_address)
VALUES (c_id, c_name, c_addr);
END addCustomer;
END pkg_customer;
/
```

Now, you can call the procedure from an anonymous block to test it:

```sql
BEGIN
pkg_customer.addCustomer(126, 'BNETON ELECTRONICS', '2215, Venus Avenue');
END;
/
```

Remember to commit the transaction to make the changes permanent:

```sql
COMMIT;
```

Finally, you can check the inserted data:

```sql
SELECT * FROM t_customer WHERE cust_id = 126;
```

This should return the newly inserted customer.

Question

To create the package and procedure in Oracle SQL, you can follow the steps below:

Step 1: Create the package specification. This is like a function prototype in C/C++. It declares the types, variables, constants, exceptions, cursors, and subprograms available for use.

```sql
CREATE OR REPLACE PACKAGE pkg_customer AS
  PROCEDURE addCustomer(
    c_id    t_customer.cust_id%type,
    c_name  t_customer.cust_name%type,
    c_addr  t_customer.cust_address%type
  );
END pkg_customer;
/
```

Step 2: Create the package body. This is where you define the procedures and functions that were declared in the package specification.

```sql
CREATE OR REPLACE PACKAGE BODY pkg_customer AS
  PROCEDURE addCustomer(
    c_id    t_customer.cust_id%type,
    c_name  t_customer.cust_name%type,
    c_addr  t_customer.cust_address%type
  ) IS
  BEGIN
    INSERT INTO t_customer (cust_id, cust_name, cust_address)
    VALUES (c_id, c_name, c_addr);
  END addCustomer;
END pkg_customer;
/
```

Now, you can call the procedure from an anonymous block to test it:

```sql
BEGIN
  pkg_customer.addCustomer(126, 'BNETON ELECTRONICS', '2215, Venus Avenue');
END;
/
```

Remember to commit the transaction to make the changes permanent:

```sql
COMMIT;
```

Finally, you can check the inserted data:

```sql
SELECT * FROM t_customer WHERE cust_id = 126;
```

This should return the newly inserted customer.

Knowee AI · Accepted Answer