1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
FUNCTION p_search_inventory (
p_inventoryname IN VARCHAR2,
p_id IN VARCHAR2,
p_molfile IN CLOB,
)
RETURN treagentcur
IS
out_cursor treagentcur;
BEGIN
OPEN out_cursor FOR
SELECT ID molecule_id, ID batch_code, NAME batch_name
FROM fake_chem_structure
WHERE DECODE (p_inventoryname,
NULL, 'TRUE',
DECODE (inventory_name,
p_inventoryname, 'TRUE',
'FALSE'
)
) = 'TRUE'
AND DECODE (p_id,
NULL, 'TRUE',
DECODE (ID, (SELECT ID
FROM DUAL
WHERE ID LIKE p_id), 'TRUE', 'FALSE')
) = 'TRUE'
AND DECODE (TO_CHAR (p_molfile),
NULL, 'TRUE',
DECODE (TO_CHAR (molfile),
TO_CHAR (p_molfile), 'TRUE',
'FALSE'
)
) = 'TRUE'
ORDER BY ID, BARCODE, CATALOG_NUMBER;
RETURN out_cursor;
END; |
Partager