PL SQL Developer插件开发文档.pdf

《PL SQL Developer插件开发文档.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、PL/SQLDeveloperPlug-IninterfaceDocumentationVersion2.10ofPL/SQLDeveloperintroducedaPlug-Ininterface.ThepurposeofthisinterfaceiseasyexternaladditionofnewfunctionalitytoPL/SQLDeveloper.Plug-InsshouldbeusedtoaddfunctionstoPL/SQLDeveloperthatarenotverywellsuitedasbuilt-infun

2、ctions.ReasonstobuildaPlug-Incouldbetoaddsomecompanyorproductspecificfunctions.YoucouldalsoconsidertobuildcommercialPlug-Ins(nolicensefeerequired).WewilldistributesomePlug-Insofourownonourwebsite(severalinterfacestoversioncontrolsystems),wecanalsopromoteyours(commercialo

3、rnot)ifyouwish.APlug-InisaDLL,soifyouareusingaprogramminglanguagethatcancreateDLL’s,youcancreatePL/SQLDeveloperPlug-Ins.OnstartupPL/SQLDeveloperwillcheckcertaindirectoriesfor*.dllfileswhichwillbeloadedifcertainkeyfunctionsareavailable.IfoneormorePlug-Insarefound,theconfi

4、gurationmenuitemisenabledwhichallowsanend-usertoactivateorde-activatePlug-Ins.TheinterfaceisbuiltinC++style.ThismeansthatifyouareusinganonC++language(likeDelphi)youshouldmakesurethatyouforceallcalls(exportfunctionsandcallbacks)totheC++callingconvention.Topreventprogrammi

5、nglanguageincompatibilitieswelimitedthenumberofdifferentparameterstothree,Boolean(32bit),Integer(32bit)andzeroterminatedstrings.Ifyoushouldfindabugorifyouhavewishesforadditionalfunctions,justletusknowandwewilltrytoimprovetheinterface.We’llmakesurehoweverthatanymodificati

6、onstotheinterfacewillbeupwardcompatible.BasicfunctionsTherearetenfunctionsthatcanbeexportedfromtheDLL.ThreeofthesefunctionsarerequiredforPL/SQLDevelopertorecognizeaDLLasaPlug-In.BelowarethebasicfunctionstocreateafunctionalPlug-In.NOTE:Startinginversion500,onlytheIdentify

7、PlugInfunctionisrequiredasanecessaryfunctionforPL/SQLDevelopertorecognizethePlug-In.Plug-InPrimaryfunctionsIdentifyPlugInC++char*IdentifyPlugIn(intID)DelphifunctionIdentifyPlugIn(ID:Integer):PCharThisfunctionreceivesaPlug-InIDfromPL/SQLDeveloperandshouldreturnadescriptio

8、nforthePlug-In.ThereturneddescriptionshouldbeuniqueforyourPlug-InandwillbedisplayedinthePlug-Inconfigur