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 <d...@madmode.com> 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 Center for Health Information Partnerships, Northwestern University, Feinberg School of Medicine 633 N. Saint Clair Street, 20th floor, Chicago, IL 60611 Web: http://furmanchuk.com/ E-mail: alona.furmanc...@northwestern.edu <furmanc...@icnanotox.org> Phone: 312-503-34281
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev