sql开发人员插件接口plugin.pdf

PL/SQLDeveloperPlug-IninterfaceDocumentation

Version2.10ofPL/SQLDeveloperintroducedaPlug-Ininterface.Thepurposeofthisinterfaceiseasy

externaladditionofnewfunctionalitytoPL/SQLDeveloper.Plug-Insshouldbeusedtoaddfunctions

toPL/SQLDeveloperthatarenotverywellsuitedasbuilt-infunctions.ReasonstobuildaPlug-In

couldbetoaddsomecompanyorproductspecificfunctions.Youcouldalsoconsidertobuild

commercialPlug-Ins(nolicensefeerequired).WewilldistributesomePlug-Insofourownonourweb

site(severalinterfacestoversioncontrolsystems),wecanalsopromoteyours(commercialornot)if

youwish.

APlug-InisaDLL,soifyouareusingaprogramminglanguagethatcancreateDLL’s,youcancreate

PL/SQLDeveloperPlug-Ins.OnstartupPL/SQLDeveloperwillcheckcertaindirectoriesfor*.dllfiles

whichwillbeloadedifcertainkeyfunctionsareavailable.IfoneormorePlug-Insarefound,the

configurationmenuitemisenabledwhichallowsanend-usertoactivateorde-activatePlug-Ins.

TheinterfaceisbuiltinC++style.ThismeansthatifyouareusinganonC++language(likeDelphi)

youshouldmakesurethatyouforceallcallportfunctionsandcallbacks)totheC++calling

convention.Topreventprogramminglanguageincompatibilitieswelimitedthenumberofdifferent

parameterstothree,Boolean(32bit),Integer(32bit)andzeroterminatedstrings.

Ifyoushouldfindabugorifyouhavewishesforadditionalfunctions,justletusknowandwewilltryto

improvetheinterface.We’llmakesurehoweverthatanymodificationstotheinterfacewillbeupward

compatible.

Basicfunctions

TherearetenfunctionsthatcanbeexportedfromtheDLL.Threeofthesefunctionsarerequiredfor

PL/SQLDevelopertorecognizeaDLLasaPlug-In.Belowarethebasicfunctionstocreatea

functionalPlug-In.

NOTE:

Startinginversion500,onlytheIdentifyPlugInfunctionisr