General discussion

Locked

MS VC++ and ORACLE8 - HELP!

By r.deguzman ·
Hi... I am a newbie in C++ and Oracle. However, I wanted to write pro*C++ that will run under NT like a TSR.

The logic of the pgm goes something like this.

select save_date_time into var_date_time from tabname

insert into tabname1
select * from tabname2
where tabname2.field_date_time > var_date_time

update tabname
set save_date_time = lastrec of tabname2.field_date_time

sleep for five minutes
re-execute the above statements.

Please help me and provide a skeleton code for the subject.

Thank you for all you help.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

MS VC++ and ORACLE8 - HELP!

by lde In reply to MS VC++ and ORACLE8 - HEL ...

Hi,
Probably you should not use C++, if no external (non-SQL) activity required.
If you wanna only manipulate with data inside Oracle database you can write PL/SQL stored procedure, and use DBMS_JOB package to invoke your procedure periodically. No additional daemons / TSRs are needed...
Please refer Oracle Application Developer Guide to find out detailed information about DBMS_JOB package...

Collapse -

MS VC++ and ORACLE8 - HELP!

by r.deguzman In reply to MS VC++ and ORACLE8 - HEL ...

Hi thanks for the help...

Collapse -

MS VC++ and ORACLE8 - HELP!

by r.deguzman In reply to MS VC++ and ORACLE8 - HEL ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums