PL/SQL is Oracle's procedural language extension to Oracle's SQL language. Because PL/SQL statements are managed by the same engine that manages SQL statements, PL/SQL statements may be incorporated into your Clarion programs in the same manner as SQL statements. For example:
SQLFile FILE,DRIVER('Oracle'),NAME(SalaryFile)
Record RECORD
SalaryAmount PDECIMAL(5,2),NAME('JOB')
END
END
CODE
SqlFile{PROP:SQL} = |
'DECLARE ' &|
'TempPhoneArea clarionclient.PhoneArea%type; '&|
'CURSOR AreaCursor IS ' &|
'SELECT PhoneArea ' &|
'FROM ClarionClient ' &|
'WHERE PhoneArea = 305; ' &|
'BEGIN ' &|
'OPEN AreaCursor; ' &|
'LOOP ' &|
'FETCH AreaCursor INTO TempPhoneArea; ' &|
'EXIT WHEN AreaCursor%NOTFOUND; ' &|
'UPDATE ClarionClient ' &|
'SET PhoneArea = 954; ' &|
'END LOOP; ' &|
'CLOSE AreaCursor; ' &|
'COMMIT WORK; ' &|
'END;'