[eluser]selvercode[/eluser]
see this function :
FUNCTION ADD_PRODUCT($new_product_array1) {
$values = array(487, 'product_name', random_string());
$query['dsa']= $this->db->query("CALL PRODUCT_ACTIONS.INSERT_PRODUCT(?, ?,?)", $values);
echo "ok";
}
--------------
this PL/SQL function
FUNCTION ADD_PRODUCT
(
PRODUCT_ID IN NUMBER ,
PRODUCT_NAME IN VARCHAR2 ,
PRODUCT_NUMBER IN VARCHAR2,
resultt OUT VARCHAR2
) RETURN VARCHAR2 AS
BEGIN
resultt := 'true';
Insert into PRODUCTS (PRODUCT_NAME,PRODUCT_NUMBER,PRODUCT_TYPE,QUANTITY,MEASURMENT_UNIT,PRODUCT_SIZE,ADDED_DATE,MODIFIED_DATE,NOTES) values (PRODUCT_NAME,PRODUCT_NUMBER,'sdsa',1112,'aasd','asd',null,null,'asdasd');
RETURN resultt;
END ADD_PRODUCT;
-------------------------------
the result it insert into database but display error and not return value???