> > Sorry, could not provide logs since i do not have PCORNET in oracle > formats. > I downloaded oracle database express edition 11 g and sql developer. For > this project I created small tables with couple of lines in them. Was > testing commands on them one by one, to be sure they are working in oracle. > Please, add `on commit preserve rows' whenever you think it is needed. > > Differently from transact-sql version, this one is no means final full > proof code since I am using oracle for less than one week now. Will > appreciate help from you to make sure code is running fine on your > database. > > >
> On Wed, Dec 14, 2016 at 9:02 AM, GPC Informatics <[email protected]> wrote: > >> #546: Oracle port of NextDextractionCode_12.1.16.sql >> --------------------------+--------------------------- >> Reporter: dconnolly | Owner: afurmanchuck >> Type: task | Status: assigned >> Priority: major | Milestone: next-d >> Component: data-sharing | Resolution: >> Keywords: | Blocked By: >> Blocking: 545 | >> --------------------------+--------------------------- >> >> Comment (by dconnolly): >> >> I don't see how this code could work. >> >> I don't recognize `capricorn.dbo.ENCOUNTER` as Oracle syntax for a table >> reference. And the temporary tables don't have `on commit preserve rows`. >> >> Do you have a log of running the code that I could look at? >> >> -- >> Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/546# >> comment:3> >> gpc-informatics <http://informatics.gpcnetwork.org/> >> Greater Plains Network - Informatics >> > > > > -- Al’ona Furmanchuk, Ph.D. Research Associate Department of Electrical Engineering and Computer Science Northwestern University 2145 Sheridan Road, Tech L359 Evanston, IL 60208 Web: http://furmanchuk.com/ E-mail: [email protected] <[email protected]> Phone: 847-467-2299
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
