Error: {"OCI-22303: type \"{SCHEMA}\".\"{UDTTYPE}\" not found"}

To resolve the error You have to:

- Use UPPERCASE for your type: for example "VIBRIP.PRODUCTNESTEDTABLE" where VIBRIP is schema name and PRODUCTNESTEDTABLE is your type name

- Grant execute on your type for the user you are connected to Oracle

GRANT EXECUTE ON PRODUCTNESTEDTABLE TO user;

where user is the user that should access the type.

ORA-06550, PLS-00306: wrong number or types of arguments in call to…

Hi There,
I think that I can help you somewhere because I got this problem. I'm working with oracle 10g and VB.NET 2008.
I was stucked since 3 weeks searching the resolution for this kind of error.
Fortunately, I've resolved it today.
It's very dummy I think but it worked lool.
You have to pass all your OUT parameters in right order fiirst before that those of IN ones.
cmd.Parameters.Add("p_task_id", OracleDbType.Int32).Direction = ParameterDirection.Output;
and then
cmd.Parameters.Add("p_task_status", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
cmd.Parameters["p_task_status"].Value = TaskStatus.COMPLETED;
That's it I think.
Hope this will help you.
Viele Glück.
Walid

Reference

Develop a File IO ActiveX control in Microsoft .NET

Development

1. Use this guide to create your own ActiveX control

Writing an ActiveX Control in .NET

2. Design your ActiveX as picture bellow:

3. Use following code behind

namespace FileIOActiveXControl
{
    public partial class WriteToClientControl : UserControl
    {
        public WriteToClientControl()
        {
            InitializeComponent();
        }

        private void btnWrite_Click(object sender, EventArgs e)
        {
            WriteLog(@"c:\temp\log.txt", txtUserInput.Text);
        }

        public void WriteLog(string fileName, string content)
        {
            try
            {
                StreamWriter log = new StreamWriter(fileName, true);
                log.WriteLine(content);
                log.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
    }
}

4. Create TestActiveX.htm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<body>
<hr>
Please note that you MUST load this HTML document from your local IIS, or from a TRUSTED SITE or the control will not load properly on the page due to security policy.
<br>
To fix this:<br>
<li>copy the HTM file and the DLL into your c:\inetpub\wwwroot folder (or applicable IIS root directory)
<li>load the document in your browser with the url:  http://localhost/TestActiveX.htm
  <hr>
	<font face=arial size=1>
	 <OBJECT id="fileIOActiveX" name="fileIOActiveX" classid="http:FileIOActiveXControl.dll#FileIOActiveXControl.WriteToClientControl" width="450" height="100" VIEWASTEXT>
	 </OBJECT>
	</font>
  <hr>
 </body>
</script>
</html>

Deployment

1. Copy FileIOActiveXControl.dll and TestActiveX.htm to the same folder

2. Go to IIS to create a new web site and point to that folder

3. Use another computer to test your control.

If you control cannot load to page like picture bellow.

a. Try to add the site to Trusted Zone in IE

b. Make sure .dll and .htm in the same folder

If your control is loaded correctly, you will see:

4. Enter some text to the textbox then click Write To File button. You may see:

“Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.”

To fix this. You have to configure Code Access Security for Microsoft .NET on client. Run following command to fix this issue.

“C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\caspol.exe -quiet -machine -chggroup Trusted_Zone FullTrust”

And  (MANDATORY if your client is running OS 64 bit)

“C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\caspol.exe -quiet -machine -chggroup Trusted_Zone FullTrust”

5. Stop IE –> reload the test page –> input some text –> click “Write To File” button again now. There will not have any error message appear. Check the log file from C:\temp\log.txt

Success.

Add Digital Signature to a PDF programmatically using Adobe SDK and Microsoft .NET

Requirement:

- Adobe Professional Installed

- Adobe SDK downloaded

- Microsoft Visual Studio

- Valid Certificate file (.pfx). It means the .pfx file not yet expired.

Setup environment:

- Copy sdkAddSignature.js from SDK to Acrobat\Javascripts folder

- Optional: Create Your Own Test Certificate

Code C#

            Type AcrobatCAcroAppType;
            AcrobatCAcroAppType = Type.GetTypeFromProgID("AcroExch.app");
            Acrobat.CAcroApp gapp = (Acrobat.CAcroApp)Activator.CreateInstance(AcrobatCAcroAppType);

            Type AcrobatPDDocType;
            AcrobatPDDocType = Type.GetTypeFromProgID("AcroExch.PDDoc");
            Acrobat.CAcroPDDoc gpddoc = (Acrobat.CAcroPDDoc)Activator.CreateInstance(AcrobatPDDocType);

            object jso;
            if (gpddoc.Open("d:\\temp\\s.pdf"))
            {
                jso = gpddoc.GetJSObject();
                object[] param = new object[1];

                param[0] = "c:\\CATest.pfx";
                object con = jso.GetType().InvokeMember("SetUserDigitalIDPath",
                BindingFlags.InvokeMethod, null, jso, param);

                param[0] = "testpassword";
                con = jso.GetType().InvokeMember("SetUserPassword",
                BindingFlags.InvokeMethod, null, jso, param);                    

                param[0] = jso;
                con = jso.GetType().InvokeMember("AddSignature",
                BindingFlags.InvokeMethod, null, jso, param);        
            }

Code VB:

        Dim gapp As Acrobat.CAcroApp
        Dim gpddoc As Acrobat.CAcroPDDoc
        Dim jso As Object
        gapp = CreateObject("acroexch.app")
        gpddoc = CreateObject("acroexch.pddoc")

        If gpddoc.Open("d:\temp\s.pdf") Then
            jso = gpddoc.GetJSObject()
            jso.SetUserPassword("testpassword")
            jso.SetUserDigitalIDPath("/C/CATest.pfx") //remember this path
            jso.AddSignature(jso)
            gapp.Show()
        End If

basquang@hotmail.com

SharePoint PermissionMask

I found the values in C:\Program Files (x86)\Microsoft Office\Office14\CAML2XSL.XSL

<!-- keep in sync with global.cs!!!
	EmptyMask               =0x0000000000000000,

        // list/document perms  =0x000000000000XXXX,
        ViewListItems           =0x0000000000000001,
        AddListItems            =0x0000000000000002,
        EditListItems           =0x0000000000000004,
        DeleteListItems         =0x0000000000000008,
        ApproveItems            =0x0000000000000010,
        OpenItems               =0x0000000000000020,
        ViewVersions            =0x0000000000000040,
        DeleteVersions          =0x0000000000000080,
        CancelCheckout          =0x0000000000000100,
        ManagePersonalViews     =0x0000000000000200,
        // UnusedList10         =0x0000000000000400, /* obsolete ManageListPermission */
        ManageLists             =0x0000000000000800,
        ViewFormPages           =0x0000000000001000,
        // UnusedList20         =0x0000000000002000,
        // UnusedList40         =0x0000000000004000,
        // UnusedList80         =0x0000000000008000,

        // web level perms      =0x0000XXXXXXXX0000,
        Open                    =0x0000000000010000,
        ViewPages               =0x0000000000020000,
        AddAndCustomizePages    =0x0000000000040000,
        ApplyThemeAndBorder     =0x0000000000080000,
        ApplyStyleSheets        =0x0000000000100000,
        ViewUsageData           =0x0000000000200000,
        CreateSSCSite           =0x0000000000400000,
        ManageSubwebs           =0x0000000000800000,
        CreateGroups            =0x0000000001000000,
        ManagePermissions       =0x0000000002000000,
        BrowseDirectories       =0x0000000004000000,
        BrowseUserInfo          =0x0000000008000000,
        AddDelPrivateWebParts   =0x0000000010000000,
        UpdatePersonalWebParts  =0x0000000020000000,
        ManageWeb               =0x0000000040000000,
        UseRemoteAPIs           =0x0000002000000000,
        ManageAlerts            =0x0000004000000000,
        CreateAlerts            =0x0000008000000000,
        EditMyUserInfo          =0x0000010000000000,
        
        // special perms        =0xXXXX000000000000,
        EnumeratePermissions    =0x4000000000000000,

        // end of list
        FullMask                =0x7FFFFFFFFFFFFFFF,
	-->

GetPermissionMask

<xsl:template name="GetPermissionMask">
	
		<xsl:variable name="Permission" select="name(@*[1])"/>
		
		<xsl:choose>
			<xsl:when test="$Permission='PermEmptyMask'">0</xsl:when>
			<xsl:when test="$Permission='PermViewListItems'">1</xsl:when>
			<xsl:when test="$Permission='PermAddListItems'">2</xsl:when>
			<xsl:when test="$Permission='PermEditListItems'">4</xsl:when>
			<xsl:when test="$Permission='PermDeleteListItems'">8</xsl:when>
			<xsl:when test="$Permission='PermApproveItems'">16</xsl:when>
			<xsl:when test="$Permission='PermOpenItems'">32</xsl:when>
			<xsl:when test="$Permission='PermViewVersions'">64</xsl:when>
			<xsl:when test="$Permission='PermDeleteVersions'">128</xsl:when>
			<xsl:when test="$Permission='PermCancelCheckout'">256</xsl:when>
			<xsl:when test="$Permission='PermManagePersonalViews'">512</xsl:when>
			<xsl:when test="$Permission='PermManageLists'">2048</xsl:when>
			<xsl:when test="$Permission='PermViewFormPages'">4096</xsl:when>
			<xsl:when test="$Permission='PermOpen'">65536</xsl:when>
			<xsl:when test="$Permission='PermViewPages'">131072</xsl:when>
			<xsl:when test="$Permission='PermAddAndCustomizePages'">262144</xsl:when>
			<xsl:when test="$Permission='PermApplyThemeAndBorder'">524288</xsl:when>
			<xsl:when test="$Permission='PermApplyStyleSheets'">1048576</xsl:when>
			<xsl:when test="$Permission='PermViewUsageData'">2097152</xsl:when>
			<xsl:when test="$Permission='PermCreateSSCSite'">4194314</xsl:when>
			<xsl:when test="$Permission='PermManageSubwebs'">8388608</xsl:when>
			<xsl:when test="$Permission='PermCreateGroups'">16777216</xsl:when>
			<xsl:when test="$Permission='PermManagePermissions'">33554432</xsl:when>
			<xsl:when test="$Permission='PermBrowseDirectories'">67108864</xsl:when>
			<xsl:when test="$Permission='PermBrowseUserInfo'">134217728</xsl:when>
			<xsl:when test="$Permission='PermAddDelPrivateWebParts'">268435456</xsl:when>
			<xsl:when test="$Permission='PermUpdatePersonalWebParts'">536870912</xsl:when>
			<xsl:when test="$Permission='PermManageWeb'">1073741824</xsl:when>
			<xsl:when test="$Permission='PermUseRemoteAPIs'">137438953472</xsl:when>
			<xsl:when test="$Permission='PermManageAlerts'">274877906944</xsl:when>
			<xsl:when test="$Permission='PermCreateAlerts'">549755813888</xsl:when>
			<xsl:when test="$Permission='PermEditMyUserInfo'">1099511627776</xsl:when>
			<xsl:when test="$Permission='PermEnumeratePermissions'">4611686018427387904</xsl:when>
			<xsl:when test="$Permission='PermFullMask'">9223372036854775807</xsl:when>
			<xsl:otherwise>0</xsl:otherwise>
		</xsl:choose>
	</xsl:template>

Building batch approval ribbon in SharePoint 2010

In SharePoint 2010, We can delete multiple items but cannot with approve/reject items. So, how can user approve/reject multiple items in one time? For example TimeSheet application in SharePoint. We can create custom Ribbon then using Application page as dialog and SharePoint Server-Side object model to solve that problem. To complete your function, you have to resolve following things:

1. How we pass the selected items and list to dialog page? We use ECMAScript as following script in CommanAction funtion of the ribbon button

// Shows custom dialog using SharePoint Client JS OM
function RibbonButtonHandler() {
    var ctx = SP.ClientContext.get_current();
    var items = SP.ListOperation.Selection.getSelectedItems(ctx);
    var myItems = '';
    var k;

    for (k in items) {
        myItems += '|' + items[k].id;
    }
    var options = {       
        url: "/_layouts/BatchApprovalRibbon/UI/ApproveRejectPage.aspx?items=" + myItems + "&list=" + SP.ListOperation.Selection.getSelectedList(),
        width: 600,
        height: 400,
        dialogReturnValueCallback: demoCallback
    };

    SP.UI.ModalDialog.showModalDialog(options);
}

By passing selected items and list as text in url parameter, we can easy to get those in application page by Request.QueryString

2. In Application Page dialog, how can We approve/reject item programmatically? We cannot use item[“Approval Status”] = “approved”, we must use following scripts instead.

SPListItem item = currentList.GetItemById(Int32.Parse(id));               SPModerationInformation approvalStatus = item.ModerationInformation; approvalStatus.Status = status;                        
approvalStatus.Comment = comments;                        
item.Update();

with status is SPModerationStatusType.

3. After approve/reject Items, how can we close dialog page and refresh parent page?

First we must close  the dialog page in server-side code:

protected void CloseDialogPage()
        {
            Context.Response.Write("<script type='text/javascript'>window.frameElement.commitPopup();</script>");
            Context.Response.Flush();
            Context.Response.End();
        }

Then we call SP.UI.ModalDialog.RefreshPage(SP.UI.DialogResult.OK) in dialogReturnValueCallback function as following

function demoCallback(dialogResult, returnValue) {
    SP.UI.Notify.addNotification('Operation Successful!');
    SP.UI.ModalDialog.RefreshPage(SP.UI.DialogResult.OK);
}

Now You can use your ribbon to process batch approve/reject items.

4. But I think we should consider how to enable/disable your ribbon by condition or context. To Enable/Disable ribbon button, we use EnabledScript attribute in CommandUIHandler element in you ribbon custom action

<CommandUIHandler
          Command="Ribbon.Approval.Batch Approval.Button_CMD"
          EnabledScript="javascript:EnableRibbonButton();"
          CommandAction="javascript:RibbonButtonHandler();" />  	

And in javascript funtion, in my scenario, we want to disable the button when there isn’t any items has selected and will enable for special list only. We use following script

function EnableRibbonButton() {
    var items = SP.ListOperation.Selection.getSelectedItems();
    var ci = CountDictionary(items);   
    var listId = SP.ListOperation.Selection.getSelectedList();
    if (ci > 0 && listId == '{A32BC151-5396-4377-AFB3-B769668C3A83}') {
        return true;
    }
    return false;
}

Finally: NOTE

Keep in mind that we pass url: "/_layouts/BatchApprovalRibbon/UI/ApproveRejectPage.aspx…. It mean dialog page will called under top level sie context. So SPContext.Current always return top level site. So if You use this ribbon in subsite, You should get error message “the list does not exist”. To resolve it, We can

- change the url to: url: "/[your subsite]/_layouts/…

- In Code behind, does not use SPContext.Current.Web directly, we must find the exactly the web of the list instead. We was use

SPSite site = SPContext.Current.Site;           
foreach (SPWeb web in site.AllWebs)           
{                
        currentList = SearchListById(web, listGuid);               
        .................            
}        

SPList SearchListById(SPWeb web, Guid listId)
        {                        
            foreach (SPList list in web.Lists)
            {
                if (list.ID.Equals(listGuid))
                {
                    return list;
                }
            }
            return null;
        }

Hope this help!

ECMAScript: SP.ClientContext is undefined or null

Sometime We cannot use SP.ClientContext in Site pages, Web part pages or Application pages. Although We was following this guide from msdn

Setting Up an Application Page for ECMAScript

If so, please replace the below lines

<script type="text/ecmascript" src="/_layouts/SP.Core.js" />
<script type="text/ecmascript" src="/_layouts/SP.Debug.js" />
<script type="text/ecmascript" src="/_layouts/SP.Runtime.Debug.js" />

With

<SharePoint:ScriptLink ID="ScriptLink1" Name="sp.debug.js" LoadAfterUI="true" Localizable="false" runat="server" />

Reference MSDN